SELECT max(sell_price) AS maxPrice, product.*, product_category.category_id AS product_category FROM product, product_category,category WHERE (product.series_value = '0' OR product.series_value = 'yes') AND product.status = '1' AND product_category.category_id = category.id AND category.status = '1' AND product.id = product_category.product_id AND product_category.category_id IN (1054,1195) AND product.sell_price > 0 GROUP BY product_category.product_id ORDER BY sell_price ASC LIMIT 0, 24
Get Special Jewelry Deals | Jewelry Discounts at Van Scoy Diamonds
Made In USA 
1-336-855-0103 
